A tablespace allows superusers to define an alternative location on the file system where the data files containing database objects (such as tables and indexes) may reside.
Just simply click ->
Tablespace to open an object
pane for Tablespace. A control-click displays the popup menu
or using the object pane toolbar below, allowing you to create new, edit and
delete the selected tablespace.
Note: Tablespace was added in PostgreSQL 8.0.
Create Tablespace
To create a new tablespace
- Select anywhere on the object pane.
- Click the
from the object pane toolbar.
or - Control-click and select New Tablespace from the popup menu.
- Edit tablespace properties on the appropriate tabs of the Tablespace Designer.
Edit Tablespace
To edit the existing tablespace(manage its general etc)
- Select the tablespace for editing in the object pane.
- Control-click and select the Design
Tablespace from the popup menu or simply double-click the tablespace.
or - Click the
from the object pane toolbar.
- Edit tablespace properties on the appropriate tabs of the Tablespace Designer.
To change the name of the tablespace
- Select the tablespace for editing in the object pane.
- Control-click and select the Rename from the popup menu.
Delete Tablespace
To delete a tablespace
- Select the tablespace for deleting in the object pane.
- Control-click and select the Delete Tablespace
from the popup menu.
or - Click the
from the object pane toolbar.
- Confirm deleting in the dialog window.
Achieve Tablespace Information
To achieve a tablespace information
- Select the tablespace in the navigation pane/object pane.
- Choose View -> Object Information in the main menu.
or - Click the
from the object pane toolbar.